SELECT FIELD0009 memberCode,ORG_MEMBER."NAME" memberName,
CASE WHEN FIELD0002 IS NULL THEN 0 ELSE FIELD0002 END annualDay,
CASE WHEN FIELD0003 IS NULL THEN 0 ELSE FIELD0003 END usedAnnualDay,
CASE WHEN FIELD0004 IS NULL THEN 0 ELSE FIELD0004 END residueAnnualDay,
CASE WHEN FIELD0005 IS NULL THEN 0 ELSE FIELD0005 END workOvertime,
CASE WHEN FIELD0006 IS NULL THEN 0 ELSE FIELD0006 END canTakeDay,
CASE WHEN FIELD0007 IS NULL THEN 0 ELSE FIELD0007 END holiAnnualTime,
ORG_UNIT.CODE deptCode,
CASE WHEN FIELD0015 IS NULL THEN 0 ELSE FIELD0015 END toAnnual
FROM FORMMAIN_1100 
LEFT JOIN ORG_MEMBER ON ORG_MEMBER."ID" = FIELD0001 
LEFT JOIN ORG_UNIT ON ORG_MEMBER.ORG_DEPARTMENT_ID = ORG_UNIT."ID"
WHERE START_DATE BETWEEN "TO_DATE"("CONCAT"("TO_CHAR"("ADD_MONTHS"("TRUNC"(SYSDATE), -1),'yyyy-MM'), '-26 00:00:00'), 'yyyy-mm-dd hh24:mi:ss') 
AND "TO_DATE"("CONCAT"("TO_CHAR"(SYSDATE,'yyyy-MM'), '-26 00:00:00'), 'yyyy-mm-dd hh24:mi:ss')